

------------------------------------------------------------------------------------------------
--Nombre: SP_Obtener
--Objetivo: Retorna un registro de la tabla Material
--Creacion    : TISI(GOS) 20130226
------------------------------------------------------------------------------------------------

CREATE PROCEDURE SP_ObtenerMaterial
(
  @IDMaterial bigint
  --@CodMate varchar(12),
  --@TipoMate varchar(3),
  --@FamiMate varchar(3),
  --@SubFamiMate varchar(3),
  --@CatMate varchar(3),
  --@SubCatMate varchar(3),
  --@DescMate varchar(250),
  --@UniMedMate varchar(10),
  --@CostoPromMate decimal,
  --@PrecPromMate decimal,
  --@SaldActMate decimal,
  --@StckMinMate decimal,
  --@StckRepoMate decimal,
  --@EstadoMate int,
  --@UsuReg varchar(20),
  --@FecReg datetime,
  --@TermCnxReg varchar(50),
  --@UsuMod varchar(20),
  --@FecMod datetime,
  --@TermCnxMod varchar(50),
  --@IDEmp int
)
AS
BEGIN
  SELECT
  IDMaterial,
    CodMate,
    TipoMate,
    FamiMate,
    SubFamiMate,
    CatMate,
    SubCatMate,
    DescMate,
    UniMedMate,
    CostoPromMate,
    PrecPromMate,
    SaldActMate,
    StckMinMate,
    StckRepoMate,
    IDSede,
    EstadoMate,
    UsuReg,
    FecReg,
    TermCnxReg,
    UsuMod,
    FecMod,
    TermCnxMod,
    IDEmp
  FROM
  Material
  WHERE   
  IDMaterial = @IDMaterial
END
GO

  